﻿CREATE TABLE `{dbprofix}posts` (
  `PostID` int(11) NOT NULL auto_increment,
  `Key` varchar(64) NOT NULL,
  `Title` varchar(255) NOT NULL,
  `CategoryID` int(11) NOT NULL,
  `Summary` varchar(512) default NULL,
  `CreateDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `LastModify` datetime NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  `Comments` int(11) NOT NULL default '0',
  `Hits` int(11) NOT NULL default '0',
  `IsApproved` tinyint(1) NOT NULL default '1',
  `Body` longtext NOT NULL,
  `LogoUrl` varchar(255) default NULL,
  PRIMARY KEY  (`PostID`),
  UNIQUE KEY `{dbprofix}Posts_key_unique` (`Key`),
  KEY `{dbprofix}Posts_title_indexed` (`Title`),
  FULLTEXT KEY `{dbprofix}Posts_body_indexed` (`Body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;